Introduction:

Detailed Benchmarking is a method of evaluating various aspects of a hotels annual consumption data against UK benchmarks provided by the Carbon Trust. By providing data for a number of hotels; either in the same chain of hotels or within the same city or region, the results can illustrate the current performance against other hotels. By taking into account climatic data and normalising the data using Normalised Performance Indicators (NPI's) a true comparison can be made. Further Benchmarking Analysis is provided by taking in account sleepers sold and rooms sold, and comparisons are made against the average of all the data entered.

This idea is that this area of the tool will alert hotels to new methods, ideas and tools to improve their annual consumption performance.

Method:

By entering the hotels data in the main data entry page the first line of the detailed benchmarking in blue will be filled in.

To complete the detailed benchmarking the white fields below the current hotel should be filled with the same data and complete the following drop down menus:

• Year selection - the tool has been set up to analyse the previous 4 years (2004 to 2007)
• Exposure - select the exposure of the hotel from; city centre, urban/rural and coastal/hilly site
• Region - select the region in the UK and Nothern Ireland that the hotel is located.

Enter the following data for each hotel:

• Hotel Name.
• Floor Area.
• Number of Rooms.
• Rooms Sold and Sleepers Sold.
• Annual Energy and Resource Consumption (Gas, Electricity and water).

Tick the following boxes if your hotel has either of the following:

• Air Conditioning
• Swimming Pool

The analysis Table below the data entry table will take the data entered from each hotel and carry out the folllowng analysis:

1. For Gas 46%* of the consumption is calculated
2. For electricity 58.5%* of the consumption is calculated
3. Both of percentages are multiplied by the weather coefficient and the exposure coefficient, calculated from the exposure and region drop down menu selections.
4. Adding this value to percentage of gas and electricity associated with non-space heating, a new total consumption value for gas and electricty is shown.

* this percentage is taken from the Carbon Trust as the typical percentage associated with space heating in hotels

Results

Results are found on the spreadsheet labelled Benchmarking Results. Gas, Electricity and Water benchmark results are shown with the following data:

• Hotel Name and consumption rating dependent on the variables selected on the previous spreadsheet.
• Benchmark table reference that refers to the tables on the Hotel Perfomance spreadsheet.
• Consumption data before and after normalised perfomance indicators have been used.
• Consumption data per room sold and per sleeper sold

Further benchmarking takes the current results and divides them by the rooms sold and the sleepers sold. This provides an in depth analysis of the consumption data and benchmarks the results against the other hotels. There is a further set of results that compare the users hotels against the average of all the data entered.